
/*
*Released on 28th June 2008.
*Any violations can be reported at paritosh@wikiocean.net
*What is treated as violations can be found at www.wikiocean.net/ppl1-voilations*
******************************************************************************
* The contents of this file are subject to POOL Public License 1.0 and later.
* POOL Public License is based on Affero GPL v3 and additional conditions.
* ("License"); You may not use this file except in compliance with the License
* You may obtain a copy of the Affero GPL v3 License at http://www.gnu.org/licenses/agpl.html
* You may obtain a copy of the POOL Public License 1.0 or later at www.wikiocean.net/license/ppl.html
* Software distributed under POOL Public License 1.0 is distributed on an "AS IS" basis,
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
* the specific language governing rights and limitations under the License.
* The Initial Developer of the Original Code is Paritosh Pungaliya (C) 2008. All Rights Reserved.
******************************************************************************
* Objective of the additional terms (license)
* 1) Is to extend the software freedom to freedom to work.
* 2) To ensure that knowledge is free from monopoly of agencies.
* 3) To avoid a situation where big corporate or investor can buy out free software groups and companies and then start milking the communities built around it.
* (this trend can be seen how the freedom is curtailed in companies that get Venture Capital funding.)
******************************************************************************
*/

package  query.view;

import java.util.Hashtable;
import java.util.Map;
import java.util.Vector;

import logger.PoolLogger;

import dbmanager.DBManager;
import dbmanager.GetIdName;

public class Condition implements Reportview
{
	String Query;
	boolean ReportFlag;
	GetIdName gid;	
	Hashtable<Object, Object> ConditionMap = new Hashtable<Object, Object>();
	Vector<Object> Condition= new Vector<Object>();
	StringBuffer FinalBuffer =new StringBuffer();
	String buffer[];
	String object;
	int Querycount=1;
	Hashtable<Object, Object> reportmap =new Hashtable<Object, Object>();
	PoolLogger pl;
	
	public Condition() {
		// logger
		pl = (PoolLogger) PoolLogger.getLogger(this.getClass().getName());
	}
	
	public void initPool()
	{
		gid = new GetIdName();
	}
	
	public void initializeData()
	{
		 
	}
	
	public String [] getbuffer()
	{
		 return buffer;
	}
	
	 @SuppressWarnings("unchecked")
	public void getResult()
	 {
		 if(Querycount==1 && Condition.size()>0)
			 Query  = Query  + " WHERE ";
		 String ConditionStr="";
		 String ALIES="p_" + Querycount+".";
		 for(int i=0;i<Condition.size();i++)
		 {
			 ConditionMap.clear();
			 ConditionMap.putAll((Map<? extends Object, ? extends Object>) Condition.get(i));
			 ConditionStr = ConditionStr + " " +ALIES  + ConditionMap.get(query.condition.Condition.CONDITIONFIELD) + ConditionMap.get(query.condition.Condition.CONDITIONOPERATOR) + "'"+ ConditionMap.get(query.condition.Condition.CONDITIONVALUE)+ "'";
			 
			 if(ConditionMap.containsKey(query.condition.Condition.LOGICALOPERATOR))
			 {
				 String LOGICALOPERATOR= " " + ConditionMap.get(query.condition.Condition.LOGICALOPERATOR);
				 ConditionStr = ConditionStr +LOGICALOPERATOR+" ";
			 }
		 }	 
		 String tempQuery=Query;
		 if(Condition.size()>0)
			 Query = Query.substring(0,tempQuery.indexOf("WHERE")+5) + ConditionStr +Query.substring(tempQuery.indexOf("WHERE")+5, tempQuery.length());
	 }
	

	public String getQuery() 
	{
			return Query;
	}	
	public int getQuerycount() 
	{
		return 0;
	}
	public void setQuery(String Query) 
	{
		this.Query = Query;
	}
	public void setQueryCount(int count) 
	{
		this.Querycount = count;
	}	
	@SuppressWarnings("unchecked")
	public void setReportMap(Hashtable<Object, Object> reportMap)
	{
		System.out.println(reportMap);
		try 
		{
			if(reportMap.containsKey("condition"))
			Condition= (Vector<Object>) reportMap.get("condition");
		}
		catch (Exception e) 
		{
			e.printStackTrace();
		}
		this.reportmap.putAll(reportMap);
	}	
	public void setMaxQuerycount(int count) 
	{
	
		
	}
	public void setReportName(String Reportname) 
	{
		
	}

	public void setObject(String Object) 
	{
		
	}

	public Hashtable<Object, Object> getReportMap() 
	{
		return reportmap;
	}

	
}

